Scott Orsey
Scott Orsey
Reactions
-
Re: Counting two things for a formula
@laura.sandoval Basically it means "not equal to blank". It's the opposite of ="". "" is a null value since there is nothing between the quotes.1 · -
Re: How to check the Duplicate rows except the first occurance
Hi @malanto, Since ROWID is always ascending, the most recent will have the largest value. So Just swap the MAX() function for the INDEX() function. In your case: =IF([ROWID]@row <> MAX(COLLECT…2 · -
Re: "Why not?" Enhancement Requests that Smartsheet Should Just Do
Thanks @Genevieve P. I have posted the additional 5 ideas to the idea section. I am also just interested in just commiserating. I know it's impossible for a development team to do everything. Hope th…1 · -
Re: Looking for solution for Forms to add multiple rows to a sheet
Hi @CamrynR, Happy to try to help. I'll tackle the helper columns one at a time: In the Source Sheet: Count of Rows: The formula depends on how you structured your form. In my case I had a separate &…2 · -
Re: Looking for solution for Forms to add multiple rows to a sheet
Hi, I realize your question is a bit old at this point and I hope you found a solution that works for you. The approach I took did not require a premier app or integration. I utilized 2 sheets. The f…1 ·
